SQLConnect Floating Point Exception
am 15.04.2011 22:46:21 von mike.rawlins --_004_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_
Content-Type: multipart/alternative;
boundary="_000_825744553010424695E4355C4DD3FDBD128B595766AME RICASMAIL0_"
--_000_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
All,
Trying to use MySQL ODBC drivers on RHE Linux to connect from a user writte=
n program to MySQL database on a remote machine. I downloaded the latest d=
rivers this past week, and unixODBC refreshed on machine a few days ago. =
I have small demo program I'm trying to make work before we bring up the fu=
ll application.
I can step through the code OK through SQLSetConnectOption, but when I hit =
SQLConnect it throws a floating point exception.
If I hack the name of the driver file in $ODBCINI the program can't find th=
e driver, so I suspect it's actually getting into the driver.
Any ideas?
Here's my (sanitized) odbc.ini file:
[ODBC Data Sources]
MIKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL
[MIKEMYSQL]
driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc5.so
description=3DConnector ODBC 3.51 Driver DSN
server=3Dxxx.xxx.com
port=3D3306
database=3DYY53
option=3D0
Thanks,
Mike
Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas, TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com
GXS Blog
[cid:image001.gif@01CBFB83.97F87080]
--_000_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:ns0=3D"urn:sche=
mas-microsoft-com:office:smarttags">
ontent=3D"text/html; charset=3Dus-ascii">
Microsoft Word 12 (filtered medium)">
nk=3Dpurple>
p class=3DMsoNormal>Trying to use MySQL ODBC drivers on RHE Linux to connec=
t from a user written program to MySQL database on a remote machine. =
I downloaded the latest drivers this past week, and unixODBC refreshed on m=
achine a few days ago. I have small demo program I’m tryi=
ng to make work before we bring up the full application.
lass=3DMsoNormal>
I can step throu=
gh the code OK through SQLSetConnectOption, but when I hit SQLConnect it th=
rows a floating point exception.
bsp;
If I hack the name of the driver file in=
$ODBCINI the program can’t find the driver, so I suspect it’s =
actually getting into the driver.
nbsp;
Any ideas?
Normal>
Here’s my (sanitized=
) odbc.ini file:
M=
IKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL
mal>
[MIKEMYSQL]
class=3DMsoNormal>driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc 5.so
description=3DConnector ODBC 3.51 Driver DSN
/o:p>
server=3Dxxx.xxx.com
=3DMsoNormal>port=3D3306
database=3DYY53=
option=3D0
Normal>
ass=3DMsoNormal>Thanks,
Mike
p;
y:"Verdana","sans-serif";color:gray'>
=3DMsoNormal>
if";color:gray'>Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Tec=
hnical Assessment Subcommittee
=
X 75252
+1 972.643.3101 direct
9.0pt;font-family:"Verdana","sans-serif";color:gray'>
a","sans-serif";color:#999999'>
inovis.com" title=3D"mailto:jay.melton@inovis.com">
'color:#999999'>mike.rawlins@gxs.com
=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color :#999999'>
amily:"Verdana","sans-serif";color:#999999'>
m/">www.gxs.com <=
span lang=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; =
color:#999999'>
nt-size:9.0pt;font-family:"Verdana","sans-serif";color:#9999 99'>
http://blogs.inovis.com/">GXS Blog<=
/span>
ana","sans-serif";color:#999999'>
>
image001.gif@01CBFB83.97F87080" alt=3D"GXS_2color_pos">
ass=3DMsoNormal>
--_000_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_--
--_004_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_--